<?php
defined('BASEPATH') or die('forbidden');
class Equipforge_Controller Extends Controller
{
	private $rolename;
    private $m;	//数据库连接
    private $server_info;


    function _init()
	{
		check_level(50,segment(0),segment(1));
		set_time_limit(0);

        
        //得到选择的区号
		$areanum = $_SESSION['area_selected_id'];
        if ($areanum == '') 
        {
            echo "<script>alert('" . translate('C_SELECT_AREA_TEXT') . "');</script>";
            return;
        }
        //query server mapping
        //$selectSql = "SELECT * FROM server_mapping WHERE dbtype='1' AND areanum={$areanum} ";
        $selectSql = "SELECT * FROM server_mapping WHERE dbtype='1' ";
        $this->db->query($selectSql);
        $this->server_info=$this->db->get_array('default');

        //var_dump($this->server_info);
        // db数据库
        $this->m = new MongoClient("mongodb://{$this->server_info['username']}:{$this->server_info['userpwd']}@{$this->server_info['dbip']}");
		
		if (false == $this->m) {
			//内部有提示错误，在此就不提示了
			 //echo "<script>alert(' connect areanum:$areanum error ');</script>";
            return;
		}
	}

	function index()
	{
		$this->view->display("dbequipment/equipforge/index");
	}
	function flexigrid()
	{
		list($colkey, $colsinfo, $where, $sortname, $sortorder, $offset, $rp, $page) = $this->common->get_flexigrid_params();

        $query=$_POST['query'];
        $query_type=$_POST['qtype'];
        if($query_type=='_id'){
            $filter=array($query_type=>(float)$query);
        }else{
            $filter=array($query_type=>$query);
        }
        $collection=$this->m->{$this->server_info['dbname']}->PlayerCopy;
        if($query!=''){
            $document=$collection->find($filter);
        }else{
            $document=$collection->find();
        }
        $data=array();
        $total = count($document);
        foreach ($document as $key=>$value){
            //$value['logofftime'] = get_datetime($value['logofftime']);
            //$value['loginday'] = get_datetime($value['loginday']);
            foreach ($value['main']['chapter'] as $k=>$v){
                foreach ($v['copylst'] as $a=>$b){
                    $b['_id']=$value['_id'];
                    $b['lastinvadetime']=get_datetime($value['lastinvadetime']);
                    $b['resetday']=(($value['resetday']-((date('o')<<16)))>>8)-date('W');
                    $b['curid']=$value['main']['curid'];
                    $b['curchapter']=$value['main']['curchapter'];
                    $b['chapter']=$v['chapter'];
                    $b['staraward']=$v['staraward'];
                    $b['sceneaward']=$v['sceneaward'];
                    $num=$key.$k.$a;
                    $data[$num]=array('id' => $value['_id'], 'cell' => $b);
                }

            }
        }

//		$sql = "SELECT COUNT(*) AS num FROM player_equip_forge WHERE {$where} {$exwhere}";
//		//echo " sql2:$sql ";
//		$one = $this->dbConnt->one($sql);
//		$total = $one['num'];
//		$orderby = $sortname ? "ORDER BY {$sortname} {$sortorder} " : "";
//
//		$sql = "SELECT {$colsinfo} FROM player_equip_forge WHERE {$where} {$exwhere} {$orderby} LIMIT {$offset},{$rp}";
//		$this->dbConnt->query($sql);
//		//$id = 0;
//		while ($n = $this->dbConnt->get_array('default'))
//		{
//			//print_r($n);
//			//时间需要由数字转成字符串
//			$n['time']=get_datetime($n['time']);
//			$n['status']=$this->statuslist[$n['status']]."-(".$n['status'].")";
//			$n['typeid']=$this->objectlist[$n['typeid']]."-(".$n['typeid'].")";
//			$n['roleid']=$this->nameList[$n['roleid']]."(".$n['roleid'].")";
//
//			$rows[] = array('id' => $n['gmid'], 'cell' => $n);
//			//$id = $id+1;
//		}
		//var_dump($rows);
		$result = array(
	            'page' => $page,
	            'total' => $total,
	            'rows' => $data
		);
		//$this->dbConnt->free_all();
		echo json_encode($result);
	}
	function del($id)
	{
		/*
		$area_host = !empty($_SESSION['area_selected_host']) ? $_SESSION['area_selected_host'] : '';
		$url=$area_host.$id;
		$strResult=vpost($url);
		$result=1;
		if ($strResult!=0||$strResult==FALSE)
		{
			$result=0;
		}
		json_output($result, translate('C_TIPS_ERROR_TEXT'));
		*/
	}
}
?>